Unique Override Registry entry
Specify that a user / group can save a record even if a Unique Registry entry specifies that a column or a combination of columns must be unique in order to save a record and that column or combination of columns is not unique.
The Unique Registry entry specifies that a column or a combination of columns must be unique in order to save a record. If the column or combination of columns is not unique (or empty), the record cannot be saved and a message displays warning the user to make the column or combination of columns unique.
With the Unique Override Registry entry it is possible to specify that users / groups are able to save a record that violates uniqueness.
Usage
This Registry entry can be assigned to users and groups:
Key | User | User | Group | Group | Group | Group |
---|---|---|---|---|---|---|
Key 1 | User
|
User
|
Group
|
Group
|
Group
|
Group
|
Key 2 | user | user | group | group | Default
|
Default
|
Key 3 | Table
|
Table
|
Table
|
Table
|
Table
|
Table
|
Key 4 | table | Default
|
table | Default
|
table | Default
|
Key 5 | Unique Override
|
|||||
Key 6 | column;column;... | |||||
Value | boolean |
User
|
user | Table
|
table | Unique Override
|
column;column;... | boolean |
User
|
user | Table
|
Default
|
Unique Override
|
column;column;... | boolean |
Group
|
group | Table
|
table | Unique Override
|
column;column;... | boolean |
Group
|
group | Table
|
Default
|
Unique Override
|
column;column;... | boolean |
Group
|
Default
|
Table
|
table | Unique Override
|
column;column;... | boolean |
Group
|
Default
|
Table
|
Default
|
Unique Override
|
column;column;... | boolean |
where:
column;column;... |
must match the column list specified in the Unique Registry entry to be overridden. |
boolean |
is If If Note:
In the absence of this entry, a setting of |
Example
This entry allows users in the Admin group to override the uniqueness constraint specified in the previous Unique Registry entry:
Key | Setting |
---|---|
Key 1 | Group
|
Key 2 | Admin
|
Key 3 | Table
|
Key 4 | eparties
|
Key 5 | Unique Override
|
Key 6 | BioBirthDate;NamFirst;NamLast
|
Value | true
|